for i in model_information_sheet
do
/opt/module/sqoop/bin/sqoop import --connect jdbc:mysql://node101:3306/car_warehouse  \
    --username root  --password 123456 \
    --delete-target-dir \
    -m 1 \
    --table $i \
    --target-dir /warehouse/ads_basic/car_home_warehouse/$i/2025-07-27 \
    -z \
    --compression-codec gzip \
    --null-string '\\N' --null-non-string '\\N' \
    --fields-terminated-by ',' --lines-terminated-by '\n'
done


for i in auto_home_search_log car_brand_information car_series_information keyword_mapping
do
/opt/module/sqoop/bin/sqoop import --connect jdbc:mysql://node101:3306/car_warehouse  \
    --username root  --password 123456 \
    --delete-target-dir \
    -m 1 \
    --table $i \
    --target-dir /warehouse/ads_basic/car_home_warehouse/$i/2025-07-27 \
    -z \
    --compression-codec gzip \
    --null-string '\\N' --null-non-string '\\N' \
    --fields-terminated-by ',' --lines-terminated-by '\n'
done